WPS表格Excel函数公式?答:在D4中输入或复制粘贴下列公式 =SUMIFS(SHEET1!D:D,SHEET1!C:C,C4,SHEET1!E:E,">="&SUBSTITUTE(LEFT(D$2,FIND("-",D$2)-1),".","-"),SHEET1!E:E,"<="&SUBSTITUTE(RIGHT(D$2,LEN(D$2)-FIND("-",D$2)),".","-"))下拉填充 ...
excel条件统计函数求教,能帮我解释下下面函数是什么意思不,谢谢_百度...答:LEN(SUBSTITUTE(SUBSTITUTE(B2,";",""),";",""))是计算B2单元格中”;“和”;"的分号被替换后的字符个数。这两个数相减,就是中英文分号“;”和“;"的字符的个数。即:LEN(B2)-LEN(SUBSTITUTE(SUBSTITUTE(B2,";",""),";",""))5、最后执行IF函数。如果B2中有英文分号个数LEN(B2)...